IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[or_AcceptedMentorSelectByMentee]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE dbo.[or_AcceptedMentorSelectByMentee]
Go

CREATE  PROCEDURE  dbo.[or_AcceptedMentorSelectByMentee]  
	@MenteeID int
AS


SELECT 
	m.MeMaUserID ,
	UserTypeID	 ,				
	FirstName	 ,
	LastName	 ,
	Email		 ,
	Password	 ,
	IsActive	 ,
    m.LastModDate  ,
    m.CreatedDate       
    FROM MeMaUser m  join MentorMentee mm ON mm.MentorID = m.MeMaUserID
    where mm.MenteeID = @MenteeID and isaccepted = 1
